import pandas as pd

employees = pd.read_excel('Employees.xlsx', index_col='ID')
#默认为空格
df = employees['Full Name'].str.split(' ',expand=True)
employees['First Name'] = df[0]
employees['Last Name'] = df[1]
print(employees)
